Eecient Incremental Evaluation of Queries with Aggregation

نویسندگان

  • Raghu Ramakrishnan
  • Kenneth A. Ross
  • Divesh Srivastava
  • S. Sudarshan
چکیده

We present a technique for eeciently evaluating queries on programs with mono-tonic aggregation, a class of programs deened by Ross and Sagiv. Our technique consists of the following components: incremental computation of aggregate functions , incremental xpoint evaluation of monotonic programs and Magic Sets transformation of monotonic programs. We also present a formalization of the notion of incremental computation of aggregate functions on a multiset, and upper and lower bounds for incremental computation of a variety of aggregate functions. We describe a proof-theoretic reformulation of the monotonic semantics in terms of computations , following the approach of Beeri et al.; this reformulation greatly simpliies the task of proving the correctness of our optimizations.

برای دانلود رایگان متن کامل این مقاله و بیش از 32 میلیون مقاله دیگر ابتدا ثبت نام کنید

ثبت نام

اگر عضو سایت هستید لطفا وارد حساب کاربری خود شوید

منابع مشابه

Pcube: Update-eecient Online Aggregation with Progressive Feedback and Error Bounds

Data Cubes are used in large data warehouses as a tool for online aggregation of information. Typically , online aggregation is supported by specifying a range query over a multidimensional data cube. As the number of dimensions increases, supporting eecient range queries as well as updates to the data cube becomes diicult. Another problem that arises with increased dimensionality is the sparse...

متن کامل

Efficient Incremental Evaluation of Queries with Aggregation

We present a technique for eeciently evaluating queries on programs with mono-tonic aggregation, a class of programs deened by Ross and Sagiv. Our technique consists of the following components: incremental computation of aggregate functions , incremental xpoint evaluation of monotonic programs and Magic Sets transformation of monotonic programs. We also present a formalization of the notion of...

متن کامل

Incremental Aggregation on Multiple Continuous Queries

Continuously monitoring large-scale aggregates over data streams is important for many stream processing applications, e.g. collaborative intelligence analysis, and presents new challenges to data management systems. The first challenge is to efficiently generate the updated aggregate values and provide the new results to users after new tuples arrive. We implemented an incremental aggregation ...

متن کامل

Optimizing Multiple Continuous Queries

Emerging data stream processing applications present new challenges that are not addressed by traditional DBMS technologies. To provide practical solutions for matching highly dynamic data streams with multiple long-lived and dynamically-updated continuous queries, a stream processing system should support incremental evaluation over new data, query optimization for continuous queries including...

متن کامل

Efficient Top-Down Computation of Queries under the Well-Founded Semantics

The well-founded model provides a natural and robust semantics for logic programs with negative literals in the bodies of rules. Although various procedural semantics have been proposed for query evaluation under the well-founded semantics, the practical issues of implementation for eeective and eecient computation of queries have been rarely discussed. This paper investigates two major impleme...

متن کامل

ذخیره در منابع من


  با ذخیره ی این منبع در منابع من، دسترسی به آن را برای استفاده های بعدی آسان تر کنید

عنوان ژورنال:

دوره   شماره 

صفحات  -

تاریخ انتشار 1994